Hlookup Query

Hi Team,

Can someone please help me with the below solution?

There are 3 sheets in the attached excel file. Data 1, Data 2, Output in Data 2.

I want to process information from Data 1 and Data 2 and the output should be in Data 2 sheet as indicated in "Output in Data 2" sheet. Thanks in advance!

Copy of Hlookup.xlsx

Workflow

Accepted answers

mceleavey

Hi @PrashantJP ,

this was achieved by a bit of transpose magic:

Workflow attached.

I hope this helps.

transpose_mceleavey.yxmd

All comments

mceleavey

Hi @PrashantJP ,

this was achieved by a bit of transpose magic:

Workflow attached.

I hope this helps.

transpose_mceleavey.yxmd

Jonathan-Sherman

Hi @PrashantJP,

You could achieve a HLOOKUP equivalent with a transpose and join:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

20210524 - HLookup.yxzp

atcodedog05

Hi @PrashantJP

Here is a workflow for the task.

1. Using sample tool to get last row.

2. Using transpose tool to convert rows to columns.

3. Using Find & Replace to do a Vlookup. Link

Hope this helps 🙂

Hlookup.yxmd

PrashantJP

Thanks a ton @mceleavey

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703