Vlookup Problem

[jamiguel77]

hi all

i understand how to work Vlookup funciton, if found a value return me a value, if not give me a #NA (right)


my dude is how to mark in the matrix the value?


see the image.

https://imgur.com/a/LkFjp1C


How to mark? found in the matriz?

thanks

 

[iggy_]

Not sure if this is what you are asking for but try this, it is a vlookup formula that will return "found" if a value matches something in the matrix and "not found" if there is no match in the matrix.

=IF(ISNUMBER(VLOOKUP(B1,$H$2:$H$8,2,FALSE)),"Found","Not Found")

 

[jamiguel77]

Hi friend, i think isnt the way, i know if found

but my problem is....


how to mark the value in the matriz in a new cell see the image column J2 by sample.


thanks

 

[iggy_]

You can have a lookup linking back to the other table. Try this

=IF(ISNUMBER(MATCH(H2,$B$1:$B$5,0)),"Found","Not Found")

 

[jamiguel77]

ok, yes i see i know

but nt exist other table

i want tye any value, mark on the table again capture other value mark on the table and so on...

i think the way is VBA right?

Thanks

 

[iggy_]

Do you mean that you want the word “found” to appear in the matrix table only after you type something in the lookup? Because you can do that by changing “Not Found” in the formula with just blank quotes. “ “ .

If you dont want to have a formula a formula in column J then you need to make something via VBA.

 

[Aladin Akyurek]

@ jamiguel77

It should not be that difficult to post here what that imgur shows in an Excel readable form.