how to Write a VLOOKUP function in VBA Like this

tharusha · Jan 15th 2021

HI

i need to apply this VLOOKUP function in VBA Code =IF(ISNA(VLOOKUP(E25,MpanLanka!E:E,2,FALSE)), "No", "Yes") can some one let me know to use this as a VBA code

**royUK** · Jan 15th 2021

Why use VLOOKUP in code? What are you trying to do?

I would use the .FindRange.Find method (Excel) method.

tharusha · Jan 15th 2021

hi royUK

I'm trying to do some lookups Automatically in VBA but it doesn't work in this way would you able to tell me how should i write the above function in VBA

**royUK** · Jan 16th 2021

That really doesn't answer my question. Have you looked at using .FIND?

Attach an example workbook

tharusha · Jan 18th 2021

hi royUK i have added the my VLOOKUP funtion in the sheet with a example can check whether this can be put to a VBA code

how to Write a VLOOKUP function in VBA Like this

Participate now!

Share

Tags