Excel IF Statement: if a cell equals a range of cells, then input a value from a range of cells in diff cell?
Here is the situation, I am trying to make a spreadsheet for a Kentucky Derby party where I will have all horses in Column A (sorted randomly) and all names of people who randomly draw that slot/horse in Column B. There will be multiple pools so I will use a worksheet for each pool. My goal is to use the first sheet to input the Win, Place and Show horses (1st, 2nd and 3rd) and all subsequent worksheets with pools in will be automatically updated from sheet 1. My dilemma occurs when I try to format the Win, Place and Show cells in the pool worksheets so that IF C1(WinHorse)=A1:A5, then D1(WinName) will auto update with the adjacent name in Column B associated with the winning horse. Same for the Place and Show.
A B C D
Horse1 Name1 WinHorse WinName
Horse2 Name2 PlaceHorse PlaceName
Horse3 Name3 ShowHorse ShowName
Horse4 Name4
Horse5 Name5
Thanks in advance.
Mail this post
July 13th, 2010 at 4:36 pm
=IF() isn’t what you need. =VLOOKUP() is the tool
This formula goes in the WinName position (D4) of the data sample you show. Modify the table range to stay put as you move this to the place and show positions. (Or use absolute referencing, better.)
=VLOOKUP(C1,A1:B5,2,FALSE)