Hello, I was working on a Vlookup formula that looks in two columns.
It's supposed to read.. Lookup A2 in sheet called "WD Drop" for phone number.. if its blank in Work Phone# then look for it in Personal Phone#.
Please see example. Any help will be appreciated. thank you.
how about
=IF(INDEX('WD DROP'!$F$2:$F$100,MATCH('ENTRY TAB'!A2,'WD DROP'!$A$2:$A$19,0))=0,"personal Phone # ",(INDEX('WD DROP'!$F$2:$F$100,MATCH('ENTRY TAB'!A2,'WD DROP'!$A$2:$A$19,0))))
or can use vlookup instead
you may need an IFERROR - if the employee cannot be found
and
=IFERROR(IF(A2="","",IF(INDEX('WD DROP'!$F$2:$F$100,MATCH('ENTRY TAB'!A2,'WD DROP'!$A$2:$A$19,0))=0,"personal Phone # ",(INDEX('WD DROP'!$F$2:$F$100,MATCH('ENTRY TAB'!A2,'WD DROP'!$A$2:$A$19,0))))), "Employee Not found")
to account for blank id numbers
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hello Etaf,
I need the actual personal phone number that's listed, not to specify that it's a personal number. Sorry I wasn't too clear I guess :/
Oh and there's thousands of entries... I just removed them for the example sheet. Can I use the criteria to grab the whole columns instead?
You perhaps add this to column H of WD DROP and then use a basic vlookup on column H
Formula:
Please Login or Register to view this content.
Thanks Byte, That's a simple option as well.
Not a vlookup, but this does the job.
You'll need to change the cell references highlighted in RED to suit
Please Login or Register to view this content.
EDIT: - Looks like etaf beat me to it
Last edited by MagicMan; 03-18-2024 at 11:54 AM.
sorry about that - misunderstood - i wont answer as it looks like @MagicMan has given the reply
You're all awesome.. Thank you all.
\or maybe this formula:
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
No not to lookup the different columnEDIT: - Looks like etaf beat me to it
Solution with named table.
Formula:Please Login or Register to view this content.
Try this formula in e2
=IF(VLOOKUP(A2;WD_DROP;6;FALSE)="";VLOOKUP(A2;WD_DROP;7;FALSE);VLOOKUP(A2;WD_DROP;6;FALSE))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks