VLOOKUP - One Criteria but having multiple table arrays

[mystic42]

Hi

I am trying unsuccessfully to do a Vlookup based on one lookup_value but looking into multiple columns on different worksheets.

The Lookup value is usually a text string concatenate several text and number cells together A1&B1&D1
125Apples55000 then find out if this string is present in sheet1 Column B or Sheet2 Column S ect.
If found in any column I want to return only the one result, if True 125Apples55000 or if False #N/A (or " not found")


If you have a better solution than Vlookup let me know, as I'm opened to suggestions

Any help or guidance would be greatly appreciated.


Cheers and Thans

Andrea

 

[mystic42]

Yes used the Exact function on the A1 against another sheets value in G85 the result was TRUE


Regards

Andrea

 

[DILIPandey]

Okay.

Not sure what is happening in your workbook but it worked in my system.
Are you sure that you have enabled macro and no problem on that front ?

Regards,
DILIPandey

 

[mystic42]

Hi DILIPandey

I figured out why it wasn't working Cell A1 has a formula D1&H1&G1 which equals 125Apples55000 when I use =exists(a1) it will always return 0

However if I copy Cell A1 and paste over with paste values the and use =exists(a1) it brings me the value 125Apples55000 and if not found 0, perfect

Workaround, I will just add a column and copy -> Paste with Values ... solving the problem.

Thanks very much for your help and quick response.

Regards

Andrea

 

[DILIPandey]

Correct.. after copying, you need to paste as values to enable function to work.

Cheers



Regards,
DILIPandey