Thread: How can I use an IFISNUMBER formula in conjunction with Vlookup?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How can I use an IFISNUMBER formula in conjunction with Vlookup?
Post some more details of what you want to achieve.

In the meantime, here's an example:

=IF(ISNUMBER(A1),VLOOKUP(A1,table,2,0),"")

This will perform the lookup only if A1 is a number, otherwise it will
return a blank.

Hope this helps.

Pete

On Jan 2, 8:00*pm, Dan wrote:


Reply With QuoteReply With Quote