What Am I Doing Wrong in This Formula????

C

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,870
What am I doing wrong with the formula in Col "V4"? I want it to Lookup the digits in "G4:I4" and return the Letter in Q1:U1 that it falls under. Ex: 145 should be CBE, not CDE. Thank you. I know I'm missing something very simple, but I don't see it.

Carbob
CASH 3 VTRACS MY VERSION.xls
GHIJKLMNOPQRSTUV
1VTVTVTVTVTABCDE
212345
3
41451454T136577534125CDE
53123125T146677434125DCD
63433436T155687434215DDD
VTRAC POWER TRAILS
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
In V4 try this

=INDEX($Q$1:$U$1,MATCH($G4,$Q4:$U4,0))&INDEX($Q$1:$U$1,MATCH($H4,$Q4:$U4,0))&INDEX($Q$1:$U$1,MATCH($I4,$Q4:$U4,0))

regards,
Paul
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
What is Wrong with my Formula?!?
Replies
5
Views
201
awoohaw
awoohaw
J
  • Question
Dependent dropdown with offset formula
Replies
5
Views
442
juliecooper255
J
F
  • Solved
Date Formula Error
Replies
5
Views
449
felixstraube
F
D
  • Solved
INDEX-MATCH with a vertical lookup
Replies
4
Views
471
Darren_workforce
D
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
2K
nemmi69
nemmi69

Forum statistics

Threads
1,221,631
Messages
6,160,942
Members
451,679
Latest member
BlueH1

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top