Hi
I have a vlookup which is as follows:- =VLOOKUP("Detailed Electronic Drawings",B10:K94,2,FALSE)
However I now wish to include an "OR" statement of "Detailed Mechanical Drawings" which is also located in the same B10:K94 defined area, unfortunately I am fairly new to this and can't seem to work out how?
Any help is most gratefully appreciated
Many Thanks
Neil
Perhaps something on these lines
=IF(ISNA(VLOOKUP("Detailed Electronic Drawings",B10:K94,2,FALSE)),VLOOKUP("General Electronic Drawings",B10:K94,2,FALSE), "")
However as sample workbook would be of great assistance in solving this for you.
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Given 2007 you could utilise IFERROR
quite a few superfluous columns in the VLOOKUP ranges mind you...=IFERROR(VLOOKUP("Detailed Electronic Drawings",B10:K94,2,FALSE),VLOOKUP("Detailed Mechanical Drawings",B10:K94,2,FALSE))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for your comments, unfortunately both responses have the same issue, they only work with the first part of the lookup.
I have attached a stripped down version of the spreadsheet if that helps.
Kind Regards
Neil
Sorry I can't follow the logic of your question.
K94 in your sample seems a rather random cell row, is this range, B10:K94, correct?
What do you mean by this?
What is the next part of the lookup?they only work with the first part of the lookup
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Hi Marcol,
Sorry I was in a rush and didn't really explain myself.
Firstly the vlookup will be placed in for this question lets say cell C255 and lets say I want this to lookup "Detailed Electronic Drawings" or "Detailed Mechanical Drawings" on row 23 & 24
Now a bit of background info, this is a stripped down old test spreadsheet and does not fully represent the latest version, this is the reason for B10:K94 not tallying up in the attached.
The updated version is way to big to upload.
Now back to rows 23 & 24, if you click in say D23 and select "y" in the dropdown, you will notice C23 changes to yes. Now I want to be able to vlookup these rows 23 & 24 and if either of them have yes, then the vlookup cell to update.
Neither of the two options provided does this?
Many thanks in advance
Neil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks