Combo problems

[Geoff]

G'day

I am setting up an Excel spreadsheet to give fishing club competition
results and have a list of eligible species in column A and their relevant
fight factors in column B. I have placed a Combo box with the fish from A to
MatchEntryComplete on typing, and now want to be able to have the relevant
fight factor show in cell next to Combo Box when fish is chosen.

I'm only new AND from Oz, so please be gentle lol

Thanks!
Geoff

 

[Max]

Assuming the source reference table is in Sheet1's cols A and B (FishSpecies
- FightFactor), and the combo's link cell is in A2 (in Sheet2), you could
place in B2:
=IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik