I have two tables and i want to make a formula that way
When B=E then A=Fasking.xlsx
I have two tables and i want to make a formula that way
When B=E then A=Fasking.xlsx
You have trailing spaces in Col E. Either remove those by using the TRIM function and use
In B3
=INDEX(F:F,MATCH(B3,E:E,0))
Copy down
or use
=INDEX(F:F,MATCH(B3,TRIM(E:E),0))
Confirm with Ctrl+Shift+Enter and not just Enter
Life's a spreadsheet, Excel!
Say thanks, Click *
Both formulas didn't work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks