View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
mcr1
 
Posts: n/a
Default Only 8 if A5=this, then B4=that. How can I put in more?


I sure do appreciate all of the help. Especially Pete and Hank. You
guys just laid it out there and really took the time to help when you
did not have to; you did it cause that is the kind of guys you are, and
I really do appreciate that. Thank you.
It's working out well, except for the #N/A. I cant seem to get rid of
that. I am using the exact formula that was posted he

=VLOOKUP(F5,Sheet1!$A$2:$B$5,2,FALSE)

Any final suggestions would be appreciated.

Thanks again for helping a fella out.


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=498860