View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Expanded Vlookup

Okay, I need a way to compare two cells in one workbook to two columns in
another workbook. When I find those two cells that match exactly then I need
to return a value in another column.

I figure it is some kind of an expanded Vlookup. This is what I've come up
with so far, but I can't figure out how to make it work.

=VLOOKUP(A1:B2,'[workbook]worksheet1'!$A$2:$E$1000,4,FALSE)