I have 2 columns - Col A and Col B
In column B, i am doing a Vlook up formula as below
=VLOOKUP(I:I,'Band Details'!A:G,7,0)
This should be done only when the other column A is filled with either "Krish" or "Bravo"
How can i do this?
I have 2 columns - Col A and Col B
In column B, i am doing a Vlook up formula as below
=VLOOKUP(I:I,'Band Details'!A:G,7,0)
This should be done only when the other column A is filled with either "Krish" or "Bravo"
How can i do this?
In B2:
=IF(OR(A2="Krish",A2="Bravo"),VLOOKUP(I:I,'Band Details'!A:G,7,0),"")
Formula:Please Login or Register to view this content.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks