Vlookup last column figure if the figure is a number

**SiewLee_81** · 07-17-2019, 04:02 AM

Hi Gurus,
I need your help for a formula that can pick the last columns from Sheet 1 to Sheet 2 IF the last columns is a number, else it will pick the last 2 column or last 3 columns.

Sheet 1
Sheet1.JPG

Sheet 2 result I wish to have is as below:
Sheet2.JPG

**XLent** · 07-17-2019, 04:10 AM

one option, based on screenshots, would be:

Sheet2!B2: =LOOKUP(9.99E+307,INDEX(Sheet1!$B$2:$D$4,MATCH($A2,Sheet1!$A$2:$A$4,0),0))
copied down

**SiewLee_81** · 07-17-2019, 04:23 AM

Thanks a lot. Let me copy down and study the formula. Will get back to you if I have any doubt

Vlookup last column figure if the figure is a number

LinkBack

Thread Tools

Rate This Thread

Display

Vlookup last column figure if the figure is a number

Re: Vlookup last column figure if the figure is a number

Re: Vlookup last column figure if the figure is a number

Thread Information

Users Browsing this Thread

Similar Threads

VBA: Show Subtracted Figure In Cell When Cumulative Figure Is Entered

[SOLVED] Using Linear Regression to predict a future event / performance figure / speed figure

[SOLVED] Using Linear Regression to predict a future event / performance figure / speed figure

converting a monthly figure with growth to an annual figure

[SOLVED] How to insert sub-caption for figures? figure 1, figure 2-a, figure 2-b, figure 3, ...

Sum formula to exclude monthly budget figure when actual figure is entered

Calculating monthly sales figure required to make annual turnover figure

Bookmarks

Bookmarks

Posting Permissions