Advanced search

Can anyone explain Excel/lookups in nice simple english for me?

(6 Posts)
Katymac Sun 28-Jun-09 10:25:33

AT least I think that is what I want to do blush

I have a list of numbers & next to each number is a statement

I want to type the numbers in a list on another page & have the statement magically appear in the right colour/font etc

What chance do I have?

WantThisWantThat Sun 28-Jun-09 10:41:38

I love lookups! They are the fabbiest excel things ever (how sad). Yes, you can do that though the part about the right/colour is all about how you format. You can use conditional formatting depending on the results but this is separate from the vlookup formula and is only applied to the cells with the results in it.

If you've got a list going down the way you would use vlookup - across is hlookup.

If you're using numbers like 1, 2, 3, etc. you would use vlookup(A1, c1:d4, 2, false), otherwise vlookup(A1, c1:d4, 2, true) if it was the closest match you needed.

There's loads of online help to get you started as well.

Katymac Sun 28-Jun-09 10:45:33

so I have

1.11 The cat sat on the Mat
1.12 She sells seashells


So I use Vlookup?

Katymac Sun 28-Jun-09 10:49:01

I am confused by

Lookup Value
Table array
Col index Number
Range look up

Is range lookup my list?

& lookup value where I will type in my number?

Katymac Sun 28-Jun-09 11:30:11


Can anyone clarify what each of the terms means?

Katymac Sun 28-Jun-09 11:54:56

Panic over - I worked it all out

Join the discussion

Registering is free, easy, and means you can join in the discussion, watch threads, get discounts, win prizes and lots more.

Register now »

Already registered? Log in with: