Hi,
I am trying to write a formula to say:
IF = [Status Col] = "Requires Action" OR "On Hold" THEN LOOKUP Value of [Match Status Col] and return the Match Status
Please can some help? I'm new to excel formula and not even sure if this is possible (although seems simple in my head)
A
Best to post a file really, though this might suffice.
I'm assuming the following, adjust the formula to suit your layout:
2 spreadsheets
Sheet 1
Column A = Status Col
Sheet 2
Column A = Status Column to be looked up
Column B = Status
in Sheet1!B1
=IF(OR(A1="Requires Action",A1="On Hold"),VLOOKUP(Sheet2!A1:B1000,2,0),"")
Returns Sheet2 Column B status based on the Sheet1 Status being "Requires Action" or "On Hold" otherwise returns null
Last edited by Special-K; 03-03-2020 at 09:32 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Welcome to the forum.
=IF(OR([Status Col]="Requires Action",[Status Col]="On Hold"),VLOOKUP(lookup_value,lookup_array,column,type_of_match),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks