Lookup1.xlsx
Hi
I have a data download from a system that is not very well designed and I cannot change (see attached).
What I want to do is lookup to see if the value in column A of the output sheet is present in the column A or B of the input sheet if it is I would like it to return the value in column C to Colum B of the output sheet if not return "not present" in column B of the output sheet.
JB
Hi batchjb69,
here is one option for you:
Hope it helps,
Please Login or Register to view this content.
berlan
Lookup1.xlsm
Many thanks saved me a load of work
What about if the value = "not present" it looks up to a third sheet (manual list) and again would return the value in column B. If not in column B it remains "not present"
No need for VBA for this. Put this in B2 and copy down...
=IFERROR(IFERROR(VLOOKUP(A2,Input!$A$2:$C$57,3,0),VLOOKUP(A2,Input!$B$2:$C$57,2,0)),"Not Present")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You're welcome, and thanks for the kind feedback
To also go through a manual list, if the value is not present in the input list, try if this works for you (see attached):
Best,Please Login or Register to view this content.
berlan
Berlan, thanks for the feedbackBut I think you clicked the negative rep lol...no biggie though
FDibbins, apologies! Realised it when I had pressed the button and it gave me a different response. Was meant to be positive rep added -- nice and simple solution to the problem -- as your other contributions on the forum!
Its the thought that counts, thanks for the kind words
Again, thanks for the rep points, that should make things square
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks