• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Issue with 'IF' - simple fix!

S

Sorenluk

New Member
Hello!
I am currently making a spreadsheet of data relating to horses. There is a lot of entries for me to enter in (a lot of horses!) so in order to make this easier for myself I thought I could try using an excel feature to speed up the process. In particular, in column B (named 'SIRE') I enter in the name of the horses dad, and the in column C(named 'SIRE PREFIX')I enter in the country the dad is from. Since in the horse world the dads have a lot of babies, I find myself entering the same name and location many times. All I am looking for is a way for when I type in (for example) 'Zoustar' in column B then in column C it automatically types 'Australia'. I have around 20,000 entries so far , so of course when I tried using the IF function to do this using the formula '=(IF(B2=$AY$2,$AX$2))' (which did work) I reached the nesting limit of 64. Can anyone help me simplify this problem so when I type one name the location associated with that name automatically comes up in the next column.

Thanks so much :)
 
You'll need to create a lookup table somewhere in your workbook (maybe on a new sheet) with a column for sire names and a column for their country of origin.

Then use a VLOOKUP:

=VLOOKUP(lookup_value,lookup_range,2,0)

You can Google VLOOKUP to find out more about the syntax and worked examples.

Your thread title isn't great, by the way. This does not require an IF statement, nor is it simple if you don't know how to do it! Good thread titles tell us what you aree trying to do, not how you think it should bee done or how complex you think it might be. :)
 
You must log in or register to reply here.
Back
Top