Lookup a value in 8 columns, 11 rows and return the value in 9th column same row
Lookup a value
-
-
-
Re: Lookup a value
bogey69,
Not quite sure what you're after here. Can you explain it in a bit more detail? -
Re: Lookup a value
If I have cf in a cell, in the next cell to the right I want to put a function
to lookup cf (it's in col 3, row 4) and return 18b (from col 9, row 4)[TABLE="width: 664"]
[tr]
[td]1
[/td]
[td]2
[/td]
[td]3
[/td]
[td]4
[/td]
[td]5
[/td]
[td]6
[/td]
[td]7
[/td]
[td]8
[/td]
[td]9
[/td]
[/tr]
[tr]
[td]mb
[/td]
[td]name
[/td]
[td]km
[/td]
[td]name
[/td]
[td]kh
[/td]
[td]name
[/td]
[td]cc
[/td]
[td]name
[/td]
[td]1a
[/td]
[/tr]
[tr]
[td]lew
[/td]
[td]name
[/td]
[td]bh
[/td]
[td]name
[/td]
[td]bmy
[/td]
[td]name
[/td]
[td]cb
[/td]
[td]name
[/td]
[td]1b
[/td]
[/tr]
[tr]
[td]dk
[/td]
[td]name
[/td]
[td]bc
[/td]
[td]name
[/td]
[td]br
[/td]
[td]name
[/td]
[td]my
[/td]
[td]name
[/td]
[td]18a
[/td]
[/tr]
[tr]
[td]mc
[/td]
[td]name
[/td]
[td]cf
[/td]
[td]name
[/td]
[td]ema
[/td]
[td]name
[/td]
[td]rv
[/td]
[td]name
[/td]
[td]18b
[/td]
[/tr]
[tr]
[td]bf
[/td]
[td]name
[/td]
[td]mt
[/td]
[td]name
[/td]
[td]gz
[/td]
[td]name
[/td]
[td]er
[/td]
[td]name
[/td]
[td]17
[/td]
[/tr]
[tr]
[td]cs
[/td]
[td]name
[/td]
[td]me
[/td]
[td]name
[/td]
[td]pk
[/td]
[td]name
[/td]
[td]bm
[/td]
[td]name
[/td]
[td]16
[/td]
[/tr]
[tr]
[td]ew
[/td]
[td]name
[/td]
[td]rck
[/td]
[td]name
[/td]
[td]gr
[/td]
[td]name
[/td]
[td]vk
[/td]
[td]name
[/td]
[td]15a
[/td]
[/tr]
[tr]
[td]gwy
[/td]
[td]name
[/td]
[td]kc
[/td]
[td]name
[/td]
[td]rc
[/td]
[td]name
[/td]
[td]rb
[/td]
[td]name
[/td]
[td]15b
[/td]
[/tr]
[tr]
[td]bk
[/td]
[td]name
[/td]
[td]wm
[/td]
[td]name
[/td]
[td]he
[/td]
[td]name
[/td]
[td]hp
[/td]
[td]name
[/td]
[td]14
[/td]
[/tr]
[tr]
[td]a
[/td]
[td]name
[/td]
[td]b
[/td]
[td]name
[/td]
[td]c
[/td]
[td]name
[/td]
[td]d
[/td]
[td]name
[/td]
[td]13a
[/td]
[/tr]
[/TABLE] -
Re: Lookup a value
Thanks to All looking at thread, found answer:x
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!