Thanks that works well for what i needed
--
Eric
"JBeaucaire" wrote:
You want an INDEX(MATCH() more than likely.
Read up on them he
http://skp.mvps.org/xl00002.htm
http://support.microsoft.com/kb/214142
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Eric D" wrote:
Is it possible to have a formula use both vlookup and hlookup together?
for example if i have a columns and rows that could change, but i have
labels in those that remain constant. Can i do a hlookup to find correct
column and then a vlookup to go to the right row to retrieve one value?
--
Eric